Python Job: Freight Audit (Analytics)

Job added on

Company

Shopee

Location

São Paulo - Brazil

Job type

Full-Time

Python Job Details

DepartmentOperations
LevelExperienced (Individual Contributor)
LocationBrazil - São Paulo

The Operation teams at Shopee covers the operational end-to-end process, from when the buyer searches for a product listed on the Shopee platform, to the moment the buyer receives the products. The team analyses and monitors operational KPIs across the region and conducts root cause analysis when operation performance fluctuates. The Operations team comprises Customer Service, Payment, Listings, Warehouse, Logistics, Seller Operations and Fraud. Browse our Operations team openings to see how you can make an impact with us.

Job Description:
  • Receive the data from 3PLs and confront it with the internal information, to understand if the charges are correct, using queries in SQL and creating tools in Python
  • Dive deep analysis to identify root cause, bringing solutions to issues
  • Understand and look to solve the root causes of issues in a PDCA flow
  • Download internal reports using SQL, manipulating the data with SQL or Python
  • Create scalable and transparent reporting mechanisms
  • Work and connect with intelligence and BI teams to insure all the correct technologies and data are available to make the analysis correct and ontime
  • Drive continuous improvement of solutions with the external and internal suppliers
  • Engage key stakeholders and participate in monitoring/developing insightful reports that will be used to control CPO
  • Proactively identify risks and develop and communicate solutions to contingency plans and manage those plans.

Requirements:
  • Experience writing highly optimized, advanced SQL queries for large datasets;
  • Analytical background with ability to process complex data sets using Excel and SQL (Python is a plus);
  • Advanced English